Accommodating Logical Logging under Fuzzy Checkpointing in Main Memory Databases
نویسندگان
چکیده
This paper presents a simple and effective method to reduce the size of log data for recovery in main memory databases. Fuzzy checkpointing is known to be very efficient in main memory databases due to asynchronous backup activities. By this feature, most recovery works in the past have used only physical logging schemes. Since the size of physical log records is quite large, physical logging schemes cause the recovery time to be much longer than that using logical logging schemes. In this paper, we propose a hybrid logging method that can accommodate logical logging under fuzzy checkpointing. This method significantly decreases the size of log data, and hence speeds up the recovery time. We also propose a reapplying rule in segmented MMDB, which reduces the number of log records for recovery. We evaluate the performance of the proposed methods through analytic analyses. The results show that we can reduce the size of log data to more than half, compared with those that use only physical logging.
منابع مشابه
Accommodating Logical Logging under Fuzzy Checkpointing in Main Memory Databasesy
This paper presents a simple and effective method to reduce the size of log data for recovery in main memory databases. Fuzzy checkpointing is known to be very efficient in main memory databases due to asynchronous backup activities. By this feature, most recovery works in the past have used only physical logging schemes. Since the size of physical log records is quite large, physical logging s...
متن کاملPii: S0950-5849(99)00057-9
In main memory databases, fuzzy checkpointing gives less transaction overhead due to its asynchronous backup feature. However, till now, fuzzy checkpointing has considered only physical logging schemes. The size of the physical log records is very large, and hence it incurs space and recovery processing overhead. In this paper, we propose a recovery method based on a hybrid logging scheme, whic...
متن کاملRecovering from Main-Memory Lapses
Recovery activities like logging checkpointing and restart are used to restore a database to a consistent state after a system crash has occurred Recovery related overhead is likely to form a bottleneck in a main memory database since I O activities are performed for the sole purpose of ensuring data durability In this paper we present recovery algorithms which reduce recovery related overheads...
متن کاملCheckpointing Schemes for Fast Restart in Main Memory
The potential for substantial performance improvement in a main memory database system (MMDB) is promising, since I/O activity is kept at minimum. On the other hand, due to the volatility of main memory, the issue of failure recovery becomes more complex than in traditional disk resident database systems. In this paper, we present four checkpointing schemes for the MMDB. The proposed schemes ar...
متن کامل